<!doctype html>
<html>
<head>
<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
<title>data Sharding data Masking</title></head>
<body><p>&nbsp;</p>
<p>&nbsp;</p>
<pre><code>Comparative Version:
	Mysql: 5.1.42(red curve)
	ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
Data Volume: 200w
Axis:
	X: (TEST TIMES)/DAY
	Y: TPS
Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: SELECT id,k FROM t_test WHERE id = # AND k = #
Comparative type: SELECT
</code></pre>
<p><img src='D:/git/shardingsphere-benchmark/report/scenario_1/update_single.png' alt='update_single' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
	Mysql: 5.1.42(red curve)
	ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
Data Volume: 200w
Axis:
	X: (TEST TIMES)/DAY
	Y: TPS
Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: UPDATE t_test SET pad = # WHERE id = # AND k = #
Comparative type: UPDATE
</code></pre>
<p>&nbsp;</p>
<pre><code>Comparative Version:
	Mysql: 5.1.42(red curve)
	ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
Data Volume: 200w
Axis:
	X: (TEST TIMES)/DAY
	Y: TPS
Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: DELETE FROM t_test WHERE id = # AND k = #
Comparative type: DELETE
</code></pre>
<p>&nbsp;</p>
<pre><code>Comparative Version:
	Mysql: 5.1.42(red curve)
	ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
Data Volume: 200w
Axis:
	X: (TEST TIMES)/DAY
	Y: TPS
Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
Comparative type: INSERT
</code></pre>
<p>&nbsp;</p>
</body>
</html>
